SELECT * FROM london_stages WHERE eventid IN (26972, 27014, 31114, 31292, 45960, 46000, 46013, 46026, 47112, 47122, 47126, 47137, 47142, 47154, 47159, 47171, 47177, 47190, 47196, 48898, 48907, 48908, 48911, 48912, 48921, 48922, 48925, 48926, 48936, 48937, 48940, 48941, 48950, 48951, 48954, 48964, 48966, 48968, 48970, 49048, 49446, 49459, 49469, 49473, 49482, 49486, 49497, 49501, 49515, 49995, 49999, 50008, 50011, 50021, 50024, 50033, 50036, 50039, 50050, 50059, 50062, 50255, 50261, 50621, 50633, 50642, 50645, 50654, 50657, 50666, 50669, 50678, 50682, 51105, 51180, 51189, 51192, 51204, 51213, 51216, 51225, 51229, 51239, 51242, 51684, 51711, 51720, 51723, 51732, 51735, 51748, 51757, 51760, 51769, 51772, 52324, 52333, 52336, 52348, 52357, 52360, 52369, 52372, 52381, 52384, 52519) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Old Woman's Oratory

Afterpiece Title: The Adventures of Fribble

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: Beauty and Virtue

Music: As17620226

Performances

Mainpiece Title: The Coronation Anthem, God Save The King

Afterpiece Title: The Messiah

Music: End Part I Oratorio: concerto on the violin [by Viotti (World, 28 Feb.)]-Mme Gautherot (from Paris; 2nd public performance in this Kingdom)

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End II: As17890227; End Part I: Concerto by Handel on organ-Greatorex

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17890306

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17890306

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music, From The Works Of Handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah; Grandselection 0

Performances

Mainpiece Title: L'allegro Ed Il Penseroso; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: PART III

Performances

Mainpiece Title: A Second Grand Selection 0 Of Sacred Music, From The Works Of Handel

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: Alexander's Feast 2

Afterpiece Title: PART III

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Afterpiece Title: Allegro ed il Penseroso 1 PART I

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End II: concerto on the violin-Weichsel

Performances

Mainpiece Title: A Grand Selection 0of Sacred Music From The Works Of Handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17910330

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Performances

Mainpiece Title: The First Act Of Alexander's Feast; Grand Selection 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: A Selection from Acis and Galatea

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End I: 1st concerto , Op. 3, by Geminiani-G. Ashley

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music From The Works Of Handel

Performances

Mainpiece Title: Alexander's Feast

Music: End of Part I Giardini's Sixth Concerto on the Violin by G. Ashley